<?php

include ("../libreria_php/modelo/clase_principal.php");

$objeto = new principal;

$objeto->conectar_mysql();
 
$page = isset($_POST['page']) ? intval($_POST['page']) : 1;
$rows = isset($_POST['rows']) ? intval($_POST['rows']) : 10;


$offset = ($page-1)*$rows;
 
$result = array();
 
$rs = mysql_query("select count(*) from producto");
$row = mysql_fetch_row($rs);
$result["total"] = $row[0];
 
$rs = mysql_query("select id, nombre_producto, format(precio_venta, 0) as precio_venta, precio_costo from producto limit $offset,$rows");
 
$items = array();
while($row = mysql_fetch_object($rs)){
	

    array_push($items, $row);
}
$result["rows"] = $items;

//print_r($result);
 
echo json_encode($result);




?>

